﻿CREATE PROCEDURE [dbo].[pokemons_update]
    @pokemonId int,
    @name nvarchar(256),
    @height int,
    @weight int,  
    @element int,
    @parentId int
AS
    Update Pokemons 
    Set Name = @name,
    Height = @height,
    Weight = @weight,
    Element = @element,
    ParentId = @parentId
    Where PokemonId = @pokemonId


     SELECT PokemonId, Name, Height, [Weight], Element, ParentId From Pokemons 
    Where PokemonId = @pokemonId
RETURN 0
